BEGIN;
SET @DISABLE_TRIGGERS=1;

-- LOAD DATA LOCAL INFILE 'C:\\Dokumente und Einstellungen\\sbusse\\Eigene Dateien\\fh-brb\\lehre\\datenbanken\\Praxisbeispiele\\Formel1\\Reduziert\\mysql\\data\\Land.dat'
LOAD DATA LOCAL INFILE '.\\data\\Land.dat'
   INTO TABLE Land
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\Rennstrecke.dat'
   INTO TABLE Rennstrecke
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\Saison.dat'
   INTO TABLE Saison
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\Rennstall.dat'
   INTO TABLE Rennstall
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\Rennfahrer.dat'
   INTO TABLE Rennfahrer
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\SetztEin.dat'
   INTO TABLE SetztEin
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\Rennen.dat'
   INTO TABLE Rennen
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

LOAD DATA LOCAL INFILE '.\\data\\GefahrenVon.dat'
   INTO TABLE GefahrenVon
   FIELDS TERMINATED BY ','  -- OPTIONALLY ENCLOSED BY '\''
   LINES TERMINATED BY '\n';

SET @DISABLE_TRIGGERS=NULL;
COMMIT;